<%@page import="examresult.Examresult"%>
<%@page import="examresult.ExamresultDao"%>
<%@page import="student.Student"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>考试成绩列表</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">

  </head>
  <body>
  <%@include file="checklogin.jsp" %>
 <div align="center">
	</div>
	<div align='center'>
		<table border='1px' cellspacing='0px'
			style='text-align:center;border-collapse:collapse'>
			<tr>
				<th>编号</th>
				<th>考试时间</th>
				<th>得分</th>
				<th>学生学号</th>
				<th>科目编号</th>
			</tr>
			<%
				ExamresultDao esDao=new ExamresultDao();
   				List<Examresult> list=esDao.showAllExamresults();
   				for(Examresult es:list)
   				{
			%>
			<tr>
				<td><%=es.getId()%></td>
				<td><%=es.getExam_date()%></td>
				<td><%=es.getScore()%></td>
				<td><%=es.getSt_id()%></td>
				<td><%=es.getSb_id()%></td>
			</tr>
			<%
				}
			%>
		</table>
	</div>  
  </body>
</html>
